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