UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6GCRlc6BczZyGt5DfAzA2KWl60jcUDvezHStSChY7Hg='
WHERE
key_id = '2b9ef2dacc1b15427811f65a47aac8e462280d11958fa7acc7076e43807cfb78'
AND (
token = '6GCRlc6BczZyGt5DfAzA2KWl60jcUDvezHStSChY7Hg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)