UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zvKipjTQKASd6wnWcrE4+8ZcTUr2xmLAdEDhoBNMRFA='
WHERE
key_id = '1b49003b946155340f44b667857c4696004991ceff02e7a4bb4afdde433186d8'
AND (
token = 'zvKipjTQKASd6wnWcrE4+8ZcTUr2xmLAdEDhoBNMRFA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)