UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'k8z4uwLg1K0tvqm75RUxw3QAhANW0GxYPJcPoYEAajI='
WHERE
key_id = '7d56d1d506452f35a60081bd1999cfb0a782e426e63cf0165e038c4d6cbe6870'
AND (
token = 'k8z4uwLg1K0tvqm75RUxw3QAhANW0GxYPJcPoYEAajI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)