UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5gM0vq6uY9hipcb3flbgLcGwqi007HHwaqZDk6brhN4='
WHERE
key_id = 'c11689233d51491f0489a9b2a02a5d92b951f8c5c3a962a22a00e67296a0a045'
AND (
token = '5gM0vq6uY9hipcb3flbgLcGwqi007HHwaqZDk6brhN4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)