UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CBZXxm4Xxdpz6bkwRgMnXQh3p560qL0GysIqX7DAIzw='
WHERE
key_id = '7a70ebb75dfb1214fbcb1d76d74f4a732be8c83458f3566d3bdba60ebf46ed78'
AND (
token = 'CBZXxm4Xxdpz6bkwRgMnXQh3p560qL0GysIqX7DAIzw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)