UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OZkqPzwj0T3UjU9K7bYTOMg3S/4kwqOop8h3zYvM3co='
WHERE
key_id = 'cd292836ae96fa3628ef05100306138782b9fa2a5ed4fc6e3494ca77bb83bef2'
AND (
token = 'OZkqPzwj0T3UjU9K7bYTOMg3S/4kwqOop8h3zYvM3co='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)