UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BgCbu6QjKX0Hil6+msjlx4I2H9yT8Wf9lzqBSXM3fUw='
WHERE
key_id = '0e81affd52d7dcffef7f16fa4abdc2fb44d1bb1a42a11c5cfde338e89967c19f'
AND (
token = 'BgCbu6QjKX0Hil6+msjlx4I2H9yT8Wf9lzqBSXM3fUw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)