UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XrvFqSCwo31Lq6Y2OAjqnKyaUIWYngcb/9cAcKz3IYE='
WHERE
key_id = '1666ae935b57d4b89735cde2f2b3197aae0399900efc6e625ba7c6903b49a0ff'
AND (
token = 'XrvFqSCwo31Lq6Y2OAjqnKyaUIWYngcb/9cAcKz3IYE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)