UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'm9Huldl8XjLQwvxfQhl3J8Zu3u2sl8DCC3AUIhB0LiI='
WHERE
key_id = '1a29d79eb9b43aa3db7f87cf5706fa13fbcb8aa325ed63f9fa1dad7cbedce01d'
AND (
token = 'm9Huldl8XjLQwvxfQhl3J8Zu3u2sl8DCC3AUIhB0LiI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)