UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/QTG/jbMs6wv4AYMnjIsLGCvCUmmEwxNEaCRbrRXfk8='
WHERE
key_id = '4dc253cf5687477adeb8bddd86d6a6d13daa6ef3bddaca30575e2766ccd4cc3f'
AND (
token = '/QTG/jbMs6wv4AYMnjIsLGCvCUmmEwxNEaCRbrRXfk8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)