UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BeVfgPR7DrQ75EEeQjY+ggGsuugq3oiHkxWRDCSjO94='
WHERE
key_id = '58d4546c07b93138b835a7e748185cf648c19e4d666722755a089ea7a66b8ed2'
AND (
token = 'BeVfgPR7DrQ75EEeQjY+ggGsuugq3oiHkxWRDCSjO94='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)