UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jkxO/tgOMy7wt29q4b7mWYnNcU+hf4J1eyrs113RNio='
WHERE
key_id = 'b1be032dd29067ee5d291064d359281725c4462ecbd0481d26d3c6b94de6b549'
AND (
token = 'jkxO/tgOMy7wt29q4b7mWYnNcU+hf4J1eyrs113RNio='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)