UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HIjPH/oSyTxOLbX45JOHIJb/8HCX/UcP8Fa7z+s+8JU='
WHERE
key_id = 'a7e0be3432d21f18c8d09da82f7d9d84dedb85c97e6e62bae3fb1b7bd5a5adaa'
AND (
token = 'HIjPH/oSyTxOLbX45JOHIJb/8HCX/UcP8Fa7z+s+8JU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)