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