UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rw8jnMI1h2/T6bAqRH1O8Qsfly3wy8c3L31z2hG3gmA='
WHERE
key_id = '0bacbb3b88dc81a19fd09232dc42b1a7181b948348df6c66cae17c515c26448c'
AND (
token = 'rw8jnMI1h2/T6bAqRH1O8Qsfly3wy8c3L31z2hG3gmA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)