UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '07pHWGweLuOJOS9tnTOc9+mfZEMsV18wPc70GAuotng='
WHERE
key_id = 'b2f9bf802e2cd25e0d7de60084df0582ae2c93f3b3dec1bb4809869c289bebe9'
AND (
token = '07pHWGweLuOJOS9tnTOc9+mfZEMsV18wPc70GAuotng='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)