UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'S58GjzfH8aMgNrNalGdzyO+m/mjMqzICue9Zi8hra/8='
WHERE
key_id = '89425dbc0cc7d94afc0257d73b090f3ab735ecf9fdb8df45280bbaea34404360'
AND (
token = 'S58GjzfH8aMgNrNalGdzyO+m/mjMqzICue9Zi8hra/8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)