UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'si2B9YaEgwRwjjgzcIn8CsLz1yiCCdZBeK6pZc3piB4='
WHERE
key_id = 'b12d7eec9344e1d6db3c632728bf7b5cf53eb0a8fc44697a061262ae6db4fd70'
AND (
token = 'si2B9YaEgwRwjjgzcIn8CsLz1yiCCdZBeK6pZc3piB4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)