UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hy2g7Z5rQozWd1dJLwnVbf0dth3TJ/D3t7+S3VfFQEc='
WHERE
key_id = '47f793e11c0b8bbe3166e9ddf24f6c0490fda279b3799b2f71161c32e3a57115'
AND (
token = 'hy2g7Z5rQozWd1dJLwnVbf0dth3TJ/D3t7+S3VfFQEc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)