UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6ehfS15XkN3DonMHvFO0GHqp/jlftjYbAXZsd/Bn4Yc='
WHERE
key_id = '8aaa1c9759fde0e8efa650053a883f3041643b1f0b85caee882fcb7c03130371'
AND (
token = '6ehfS15XkN3DonMHvFO0GHqp/jlftjYbAXZsd/Bn4Yc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)