UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xpsxE2siMAnbjw+TwshouHzVkLmoitMIEtMeYC63gdI='
WHERE
key_id = '6bcadcafd644a08106918099d85e28aec6a52ac2be6bb7c69d1bfff8235cc24b'
AND (
token = 'xpsxE2siMAnbjw+TwshouHzVkLmoitMIEtMeYC63gdI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)