UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pM7dNuDgfEB1cmeSuc9ty2nmKW+oUAckLVhiUXhhUsM='
WHERE
key_id = 'e407dc11bc4f75c94af8329becef94b9f9fdd1dcb8a19f62192f7fb79cb0fd32'
AND (
token = 'pM7dNuDgfEB1cmeSuc9ty2nmKW+oUAckLVhiUXhhUsM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)