UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'i+2jmYt5zieg70ABeH30nUMIgcG2U0RNO3zHpWkJR7E='
WHERE
key_id = '50d8b810b7945f2bb51d5f83b97cc35968a00ffd2f985f1e0ac84c0ae1e7ebb2'
AND (
token = 'i+2jmYt5zieg70ABeH30nUMIgcG2U0RNO3zHpWkJR7E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)