UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vvBUWvm3I2CNEq8B2odeyKlRImDKrUF8CcIJUYvEiSo='
WHERE
key_id = '8cf81b6b8b25429543bef4f600f53eb9bede685311ab4f0955b19911e672b35b'
AND (
token = 'vvBUWvm3I2CNEq8B2odeyKlRImDKrUF8CcIJUYvEiSo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)