UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'M8jLhshe2zf8+LRXIjtbk6y0Jc5cMNaro3DHYJJZviE='
WHERE
key_id = '6204d0b2fa3c6a49f8afcb7970899082c8d323083ebd23c90726f9b95a365685'
AND (
token = 'M8jLhshe2zf8+LRXIjtbk6y0Jc5cMNaro3DHYJJZviE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)