UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'n9qR2ybJG6PLKrd8xJan1WPWEhdKHsy5B6aOihSO4PA='
WHERE
key_id = '643ba583c8b847bc4249de1cd9571f874df349e1a7bc832b6a3499fc1682924e'
AND (
token = 'n9qR2ybJG6PLKrd8xJan1WPWEhdKHsy5B6aOihSO4PA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)