UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gKfp0ZYyVluVarWdxDcSs+jyJnvXCQD3joDdrBMGIbM='
WHERE
key_id = 'c096c2a791b76574dfe93ea3bd05ca06c5dfe8ff46b8f5df0647a9700f50a536'
AND (
token = 'gKfp0ZYyVluVarWdxDcSs+jyJnvXCQD3joDdrBMGIbM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)