UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1LkDU9ytInVhmYv3t0krwebOUpDW0pDknJIZPqJQ4Ds='
WHERE
key_id = '22b0992197e37875a91805f24cacbe2806ab40e98b413089cefe58ca4a55915b'
AND (
token = '1LkDU9ytInVhmYv3t0krwebOUpDW0pDknJIZPqJQ4Ds='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)