UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3DqGPeTgW6eS+rIOYHstb5GpB+AWUxpcELYEiY9G2CQ='
WHERE
key_id = '12f5936bf253db1d57347e65b665a4d1c7706c04a99119ad439caf6a586554f8'
AND (
token = '3DqGPeTgW6eS+rIOYHstb5GpB+AWUxpcELYEiY9G2CQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)