UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'k74zYtm7NW3CckvBPLn3HUugarq/b8EyHaTdpqI+9O8='
WHERE
key_id = 'c3a7e4edd94dbbcbb615937c90238cd2e5a18db536b0da3d1ef5cff2b6f1e57e'
AND (
token = 'k74zYtm7NW3CckvBPLn3HUugarq/b8EyHaTdpqI+9O8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)