UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4aoICaY4s4qdnR8ZH5FSVTfEwrAVyh7UviidbUESi1Q='
WHERE
key_id = 'e848cd38f5270642eb8e6ff171652605c9a8b8e8d1f5752fed03a8cc37486276'
AND (
token = '4aoICaY4s4qdnR8ZH5FSVTfEwrAVyh7UviidbUESi1Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)