UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jzkkjYVuYwO5dC00Is6QZ1mRLnizX3dFgIwqIz3WIh0='
WHERE
key_id = '03b0c596a963ccc6fee6c42f5a4f73d73a0104a15460bb95dbe3beeb4cb1bf05'
AND (
token = 'jzkkjYVuYwO5dC00Is6QZ1mRLnizX3dFgIwqIz3WIh0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)