UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'siA1l1aAo5TdH3Ox/ioX6pTG2YT+W+x0fVK0xa09srg='
WHERE
key_id = '7f518bcd78c36b34dff907403f47df0e43e40b1bcc9579960e7f0148b2e8391c'
AND (
token = 'siA1l1aAo5TdH3Ox/ioX6pTG2YT+W+x0fVK0xa09srg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)