UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pzYswDvNGDsvD1Hk85w5yTW/0pocTyM4MiIccKfZWbU='
WHERE
key_id = 'ead10c17ad518e4f9908eb4adaf50c15d2cc089f7e936364b5d0b438e482dc9c'
AND (
token = 'pzYswDvNGDsvD1Hk85w5yTW/0pocTyM4MiIccKfZWbU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)