UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Kch2rBUo6aEGPLhWgo6XPCzEaB7y/kd3gtBIaGMKAgw='
WHERE
key_id = 'cb4f1f71734c6b7565535c82426fa37575156698751c786eacc70f03120cd159'
AND (
token = 'Kch2rBUo6aEGPLhWgo6XPCzEaB7y/kd3gtBIaGMKAgw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)