UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3QM24bVP9miRaU0quBkT9h4Sih7Y0f8Nv+CwE46Tl7k='
WHERE
key_id = 'a47cda1694abb4371dc5316d38c7927676caaba5d27b3ad8e0652ade85125e90'
AND (
token = '3QM24bVP9miRaU0quBkT9h4Sih7Y0f8Nv+CwE46Tl7k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)