UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6XE0czVYYmtkx5eSedrXNjCsBI2zCjwJ4Qa+jSnnLyQ='
WHERE
key_id = '9f5d2651c248d2eb191c71922e84fdbf361b4838f78989298dde88d47f57464b'
AND (
token = '6XE0czVYYmtkx5eSedrXNjCsBI2zCjwJ4Qa+jSnnLyQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)