UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uJ8J3kY0f5sZLPXJAiuaDLyN27HsQPNCBTLJ5/SXHCE='
WHERE
key_id = '7a7bf59f0c6e0dcfa8dd6b86973f4f4fbf1ffc3dbf789afb8e2554832ff5b05e'
AND (
token = 'uJ8J3kY0f5sZLPXJAiuaDLyN27HsQPNCBTLJ5/SXHCE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)